CustomerAccountLinkage

Entity Definition

Logical Name : CustomerAccountLinkage
Physical Name : LE_CT_ACNT_LNKG

A general purpose join entity that allows retailers to link CustomerAccount instances together. This needs to be used thoughtfully and carefully. A sample scenario for using CustomerAccountLinkage is associating a CustomerMembershipAccount with CustomerInstalllmentPaymentAccount. This enables a retailer to tie multiple installment purchases to a club member. Another scenario is where a retailer wants to tie CustomerRevolvingChargeAccount with a RebateAccount for customer valuation purposes. While CustomerAccounts are typically tied to KeyCustomers it is not a required relationship. Also, the ability to connect specific kinds of accounts for a given customer (like CustomerMembership and Rebate accounts) may be easier to implement with this kind of join entity.

Data Definition

Attribute	Description	Physical Name	Domain	Data Type	Foreign Key Table
CustomerAccountLinkageID (PK)	Token ID for a CustomerAccountLinkage instance.	ID_CT_ACNT_LNKG	Identity	integer
To (FK)	A unique identifier for a customer account.	ID_CTAC_TO	Identity	integer	CustomerAccount(LE_CTAC)
From (FK)	A unique identifier for a customer account.	ID_CTAC_FR	Identity	integer	CustomerAccount(LE_CTAC)
AccountLinkageTypeCode	Defines a category or type of linkage created to tie two different instances of CustomerAccounts together. This is a retailer defined code. Its intent is to allow retailers to link different kinds of customer accounts together. For example they can link a customer membership account to an installment payment account. By design, this is a very open ended association so retailers can establish linkages that are appropriate for their business.	CD_ACNT_LNKG_TYP	Code	varchar(20)
AccountLinkagePurposeNarrative	A short description of how a customer account linkage (basically a join between two customer account types) is to be used.	NA_ACNT_LNKG_PRPS	DescriptionNarrative	varchar(4000)

Relationships

Parent Entity	Verb Phrase	Child Entity
CustomerAccount	is associated with	CustomerAccountLinkage
CustomerAccount	is associated with	CustomerAccountLinkage

Logical Views containing CustomerAccountLinkage

Logical View
Logical 07010 - Customer Account Information Extended